Help

Data Sources. Select the data sources for your report. You can select more than one data source.

• Table - Lists the available tables and views.
• Join Field – Lists the available fields from your selection above. Your selection here must match your selection in Field.
• Foreign table – Lists the tables and views available to join with your selection in Table.
• Field – Lists the available fields from your selection above. Your selection here must match your selection in Join Field.

Help

Fields. Add and delete fields from your selected data sources. Sort the fields and perform sort and perform functions

• Field: Lists all fields available from the tables and views selected in Data Sources.
• Description: Describes the field. Defaults to field name, but can be edited.
• Sort A: Sort by the selected Field.
• Sort D: Sort by the selected Description.
• VG: Visually groups the fields in your report.
• A: Allows you to add, subtract, multiply, or divide by the selection in the row above. Click the box to.
• Function: Allows you to perform a function on the selected Field.
• Format: Allows you to format the selected Field.

You can add a summary line to all numeric fields using:

• Avg – the average of the fields
• Count – counts how many
• Count Distinct – counts everything only once
• Min value – Minimum value of the total
• Maximum value – Maximum value of the total
• Sum – Adds the total

Field|Value. Shows field and value for every pair.

Help

Summary. View a summary of the Fields tab information.

Field|Value. Shows field and value for every pair.

Help

Chart. Create a chart for your report.

Pie: Select the Label and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by. Show as a 3D graphic, explode the largest slice, and select between a pie or a doughnut.

Trend: Select the Date and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by.

Plot: Select the X and Y values and click Sort A to indicate which one to sort by.

Bar chart: Select the Label and its corresponding function and the Value and its corresponding function. Click Sort A to indicate which one to sort by

Help

Gauge. Guages can be used to build dashboards and help users visualize critical performance data. Place the field that describes what you are measuring and a value that contains the value.

Help

Help

Style. Set colors for the border, header, item and alternating item. Click Set Default to restore system defaults.

Help

Filters. Filter available fields.

• Filter Field: - Lists the available fields.
• Operator: – Lists the operations available for the above field.
• Value(s): - Allows you to input conditions for the operation.
• Blank: - Check the box to return results with the value or a blank (null).
• Param: – Check the box to allow users to modify the parameter from the report viewer.

Help

Preview. View your report. Click on the column headings to sort in ascending or descending order.